<?xml version="1.0" encoding="UTF-8" ?>
<ActiveReportsLayout 
	GUIDLIB="{00000000-0000-0000-0000-000000000000}" GUIDREP="{00000000-0000-0000-0000-000000000000}" 
	LICENSE="10000000"
	PrintWidth="10800"
	DocumentName="ActiveReports Document"
	TOCWidth="1800"
ScriptDebuggerEnabled="1"
	ScriptLang="VBScript"
>
<Watermark
		>
</Watermark>
<Script>
<![CDATA[Sub OnReportStart

IF Organization = "-1" Then

	If GradYear = " " Then 
	
		SQL = "SELECT tblClients.fldPrimaryStudioNo, tblClients.fldName1, tblClients.fldName2, tblOrganizations.fldOrganizationName, tblClients.fldEmail, tblClients.fldCliNo, tblClients.fldLeadSource, tblClients.fldCompanyName, tblClients.fldGraduationYear, tblClients.fldState, tblClients.fldHome, tblClients.fldAdd1, tblClients.fldCity "&_
		"FROM (tblClients LEFT JOIN tblSessions ON tblClients.fldCliID = tblSessions.fldCliID) INNER JOIN tblOrganizations ON tblClients.fldOrganizationID = tblOrganizations.fldOrganizationID "&_
		"WHERE (((tblSessions.fldSesID) Is Null)) "&_
		"ORDER BY  tblOrganizations.fldOrganizationName, tblClients.fldCliNo"

	Else 
	
		SQL = "SELECT tblClients.fldPrimaryStudioNo, tblClients.fldName1, tblClients.fldName2, tblOrganizations.fldOrganizationName, tblClients.fldEmail, tblClients.fldCliNo, tblClients.fldLeadSource, tblClients.fldCompanyName, tblClients.fldGraduationYear, tblClients.fldState, tblClients.fldHome, tblClients.fldAdd1, tblClients.fldCity "&_
		"FROM (tblClients LEFT JOIN tblSessions ON tblClients.fldCliID = tblSessions.fldCliID) INNER JOIN tblOrganizations ON tblClients.fldOrganizationID = tblOrganizations.fldOrganizationID "&_
		"WHERE (((tblSessions.fldSesID) Is Null)) and tblClients.fldGraduationYear = '" & GradYear & "' "&_
		"ORDER BY  tblOrganizations.fldOrganizationName, tblClients.fldCliNo"
 
	End If

Else

	If GradYear = " " Then 
	
		SQL = "SELECT tblClients.fldPrimaryStudioNo, tblClients.fldName1, tblClients.fldName2, tblOrganizations.fldOrganizationName, tblClients.fldEmail, tblClients.fldCliNo, tblClients.fldLeadSource, tblClients.fldCompanyName, tblClients.fldGraduationYear, tblClients.fldState, tblClients.fldHome, tblClients.fldAdd1, tblClients.fldCity "&_
		"FROM (tblClients LEFT JOIN tblSessions ON tblClients.fldCliID = tblSessions.fldCliID) INNER JOIN tblOrganizations ON tblClients.fldOrganizationID = tblOrganizations.fldOrganizationID "&_
		"WHERE (((tblSessions.fldSesID) Is Null)) and tblOrganizations.fldOrganizationID = '" & Organization & "' "&_
		"ORDER BY  tblOrganizations.fldOrganizationName, tblClients.fldCliNo"

	Else 
	
		SQL = "SELECT tblClients.fldPrimaryStudioNo, tblClients.fldName1, tblClients.fldName2, tblOrganizations.fldOrganizationName, tblClients.fldEmail, tblClients.fldCliNo, tblClients.fldLeadSource, tblClients.fldCompanyName, tblClients.fldGraduationYear, tblClients.fldState, tblClients.fldHome, tblClients.fldAdd1, tblClients.fldCity "&_
		"FROM (tblClients LEFT JOIN tblSessions ON tblClients.fldCliID = tblSessions.fldCliID) INNER JOIN tblOrganizations ON tblClients.fldOrganizationID = tblOrganizations.fldOrganizationID "&_
		"WHERE (((tblSessions.fldSesID) Is Null)) and tblClients.fldGraduationYear = '" & GradYear & "' and tblOrganizations.fldOrganizationID = '" & Organization & "' "&_
		"ORDER BY  tblOrganizations.fldOrganizationName, tblClients.fldCliNo"
 
	End If
	
End If



	
	rpt.Sections("Detail").Controls("DataControl1").Source = SQL

    StudioPlus.Application.Initialize

    rpt.PageSettings.TopMargin = 720 '(1440 = 1 inch)
    rpt.PageSettings.LeftMargin = 720
    rpt.PageSettings.BottomMargin = 720
    rpt.PageSettings.RightMargin = 720

On Error Resume Next
    rpt.Image1.Width = StudioPlus.Application.Preferences.LogoWidth * 1440
    rpt.Image1.Picture = LoadPicture(StudioPlus.Application.DataPath & "\CompLogo.bmp")

    rpt.txtStudioName.Left = rpt.Image1.Width + 20
    rpt.txtReportHeader.Left = rpt.Image1.Width + 20

    rpt.txtStudioName.Text = StudioPlus.Application.Preferences.CompanyName
    rpt.txtReportHeader.Text = StudioPlus.Application.Preferences.ReportHeader 

End Sub
]]></Script>
<PageSettings>
</PageSettings>
<StyleSheet>
	<Style Name="Normal"
	Value="font-family: &apos;Arial&apos;; font-style: normal; font-variant: inherit; font-weight: normal; font-size: 10pt; font-size-adjust: inherit; font-stretch: inherit; color: rgb(0,0,0); background-color: rgb(255,255,255); background-image: inherit; background-repeat: inherit; background-attachment: inherit; background-x-position: inherit; background-y-position: inherit; opacity: inherit; word-spacing: inherit; letter-spacing: inherit; text-decoration: none; vertical-align: inherit; text-transform: inherit; text-align: inherit; text-indent: inherit; unicode-bidi: inherit; line-height: inherit; white-space: inherit; ddo-can-grow: inherit; ddo-can-shrink: inherit; ddo-char-set: 0; "
	/>
	<Style Name="Heading1"
	Value="font-family: &apos;inherit&apos;; font-style: inherit; font-variant: inherit; font-weight: bold; font-size: 16pt; font-size-adjust: inherit; font-stretch: inherit; "
	/>
	<Style Name="Heading2"
	Value="font-family: &apos;Times New Roman&apos;; font-style: italic; font-variant: inherit; font-weight: bold; font-size: 14pt; font-size-adjust: inherit; font-stretch: inherit; "
	/>
	<Style Name="Heading3"
	Value="font-family: &apos;inherit&apos;; font-style: inherit; font-variant: inherit; font-weight: bold; font-size: 13pt; font-size-adjust: inherit; font-stretch: inherit; "
	/>
	<Style Name="Heading4"
	/>
</StyleSheet>
<Sections>
	<Section Type="PageHeader" Name="PageHeader"
		Height="1530"
	>
		<Control 
		Type="AR.Label"
		Name="Label9"
		Left="6930"
		Top="90"
		Width="3690"
		Height="360"
		Caption="Seniors Without Sessions"
		ClassName="Normal"
		Style="font-weight: bold; font-size: 14.5pt; "
		>
		</Control>
		<Control 
		Type="AR.Field"
		Name="txtStudioName"
		Left="1440"
		Top="0"
		Width="5000"
		Height="270"
		Tag="12300"
		Text="StudioName"
		ClassName="Normal"
		Style="font-weight: bold; "
		>
		</Control>
		<Control 
		Type="AR.Field"
		Name="txtReportHeader"
		Left="1440"
		Top="270"
		Width="5000"
		Height="1080"
		Tag="12303"
		Text="ReportHeader"
		ClassName="Normal"
		Style="font-size: 8pt; ddo-char-set: 1; "
		>
		</Control>
		<Control 
		Type="AR.Image"
		Name="Image1"
		Left="0"
		Top="0"
		Width="1440"
		Height="1530"
		SizeMode="2"
		PictureAlignment="0"
		>
		</Control>
		<Control 
		Type="AR.Field"
		Name="Field5"
		DataField="=[GradYear]"
		Left="9180"
		Top="1080"
		Width="1440"
		Height="360"
		Text="fldGraduationYear"
		ClassName="Normal"
		Style="text-align: right; font-weight: bold; font-size: 14.5pt; "
		>
		</Control>
<Script>
<![CDATA[
Sub OnFormat

End Sub
]]></Script>
	</Section>
	<Section Type="GroupHeader" Name="GroupHeader1"
		Height="735"
		DataField="fldOrganizationName"
		ColumnLayout="0"
	>
		<Control 
		Type="AR.Label"
		Name="Label2"
		Left="0"
		Top="450"
		Width="900"
		Height="270"
		Caption="Client No"
		ClassName="Normal"
		Style="font-weight: bold; font-size: 9pt; "
		>
		</Control>
		<Control 
		Type="AR.Label"
		Name="Label3"
		Left="900"
		Top="450"
		Width="2070"
		Height="270"
		Caption="Client Name"
		ClassName="Normal"
		Style="font-weight: bold; font-size: 9pt; "
		>
		</Control>
		<Control 
		Type="AR.Label"
		Name="Label4"
		Left="3150"
		Top="450"
		Width="1440"
		Height="270"
		Caption="Home Phone"
		ClassName="Normal"
		Style="font-weight: bold; font-size: 9pt; "
		>
		</Control>
		<Control 
		Type="AR.Label"
		Name="Label5"
		Left="6930"
		Top="450"
		Width="1440"
		Height="270"
		Caption="Graduation Year"
		ClassName="Normal"
		Style="font-weight: bold; font-size: 9pt; "
		>
		</Control>
		<Control 
		Type="AR.Label"
		Name="Label6"
		Left="8460"
		Top="450"
		Width="1800"
		Height="270"
		Caption="Lead Source"
		ClassName="Normal"
		Style="font-weight: bold; font-size: 9pt; "
		>
		</Control>
		<Control 
		Type="AR.Label"
		Name="Label7"
		Left="4680"
		Top="450"
		Width="1620"
		Height="270"
		Caption="Email Address"
		ClassName="Normal"
		Style="font-weight: bold; font-size: 9pt; "
		>
		</Control>
		<Control 
		Type="AR.Line"
		Name="Line1"
		X1="0"
		Y1="720"
		X2="10800"
		Y2="720"
		>
		</Control>
		<Control 
		Type="AR.Field"
		Name="Field3"
		DataField="fldOrganizationName"
		Left="6480"
		Top="0"
		Width="4230"
		Height="450"
		Text="fldOrganizationName"
		ClassName="Normal"
		Style="font-weight: bold; font-size: 14.5pt; text-align: right; "
		>
		</Control>
<Script>
<![CDATA[
Sub OnFormat

End Sub
]]></Script>
	</Section>
	<Section Type="Detail" Name="Detail"
		Height="270"
	>
		<Control 
		Type="AR.DataControl"
		Name="DataControl1"
		Left="-5000"
		Top="0"
		Width="1500"
		Height="360"
		Visible="0"
		ConnectionString="Provider=SQLOLEDB.1;Password=Studi0Plus;Persist Security Info=True;User ID=sa;Initial Catalog=hrivol3;Data Source=bowhunt\sql2005;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=CHRISXPPRO;Use Encryption for Data=False;Tag with column collation when possible=False"
		RecordSource="SELECT tblClients.fldPrimaryStudioNo, tblClients.fldName1, tblClients.fldName2, tblOrganizations.fldOrganizationName, tblClients.fldEmail, tblClients.fldCliNo, tblClients.fldLeadSource, tblClients.fldCompanyName, tblClients.fldGraduationYear, tblClients.fldState, tblClients.fldHome, tblClients.fldAdd1, tblClients.fldCity
FROM (tblClients LEFT JOIN tblSessions ON tblClients.fldCliID = tblSessions.fldCliID) INNER JOIN tblOrganizations ON tblClients.fldOrganizationID = tblOrganizations.fldOrganizationID
WHERE (((tblSessions.fldSesID) Is Null))
ORDER BY tblClients.fldCliNo"
		LockType="1"
		>
		</Control>
		<Control 
		Type="AR.Field"
		Name="txtfldCliNo"
		DataField="fldCliNo"
		Left="0"
		Top="0"
		Width="900"
		Height="270"
		Text="fldCliNo"
		Multiline="0"
		CanGrow="0"
		ClassName="Normal"
		Style="font-size: 9pt; "
		>
		</Control>
		<Control 
		Type="AR.Field"
		Name="txtfldName2"
		DataField="=[fldName2] &amp; &quot;, &quot; &amp; [fldname1]"
		Left="900"
		Top="0"
		Width="2250"
		Height="270"
		Text="fldName2"
		Multiline="0"
		CanGrow="0"
		ClassName="Normal"
		Style="font-size: 9pt; "
		>
		</Control>
		<Control 
		Type="AR.Field"
		Name="txtfldHome"
		DataField="fldHome"
		Left="3150"
		Top="0"
		Width="1440"
		Height="270"
		Text="fldHome"
		Multiline="0"
		CanGrow="0"
		ClassName="Normal"
		Style="font-size: 9pt; "
		>
		</Control>
		<Control 
		Type="AR.Field"
		Name="txtfldEmail"
		DataField="fldEmail"
		Left="4590"
		Top="0"
		Width="2340"
		Height="270"
		Text="fldEmail"
		Multiline="0"
		CanGrow="0"
		ClassName="Normal"
		Style="font-size: 9pt; "
		>
		</Control>
		<Control 
		Type="AR.Field"
		Name="txtfldLeadSource"
		DataField="fldLeadSource"
		Left="8460"
		Top="0"
		Width="2250"
		Height="270"
		Text="fldLeadSource"
		Multiline="0"
		CanGrow="0"
		ClassName="Normal"
		Style="font-size: 9pt; "
		>
		</Control>
		<Control 
		Type="AR.Line"
		Name="Line3"
		X1="0"
		Y1="270"
		X2="0"
		Y2="0"
		>
		</Control>
		<Control 
		Type="AR.Line"
		Name="Line4"
		X1="900"
		Y1="270"
		X2="900"
		Y2="0"
		>
		</Control>
		<Control 
		Type="AR.Line"
		Name="Line5"
		X1="3150"
		Y1="270"
		X2="3150"
		Y2="0"
		>
		</Control>
		<Control 
		Type="AR.Line"
		Name="Line6"
		X1="4590"
		Y1="270"
		X2="4590"
		Y2="0"
		>
		</Control>
		<Control 
		Type="AR.Line"
		Name="Line7"
		X1="6930"
		Y1="270"
		X2="6930"
		Y2="0"
		>
		</Control>
		<Control 
		Type="AR.Line"
		Name="Line8"
		X1="8370"
		Y1="270"
		X2="8370"
		Y2="0"
		>
		</Control>
		<Control 
		Type="AR.Line"
		Name="Line9"
		X1="10780"
		Y1="270"
		X2="10780"
		Y2="0"
		>
		</Control>
		<Control 
		Type="AR.Field"
		Name="txtfldHighSchoolGradYear"
		DataField="fldGraduationYear"
		Left="6930"
		Top="0"
		Width="1440"
		Height="270"
		Text="fldHighSchoolGradYear"
		Multiline="0"
		CanGrow="0"
		ClassName="Normal"
		Style="font-size: 9pt; "
		>
		</Control>
		<Control 
		Type="AR.Field"
		Name="MWHO2241959±"
		Left="4650"
		Top="0"
		Width="1"
		Height="1"
		Text="Seniors without Sessions Report SQL±DK±Default Printer±Default Paper Bin±Custom Report±SELECT tblClients.fldName1, tblClients.fldName2, tblOrganizations.fldOrganizationName, tblClients.fldEmail, tblClients.fldCliNo, tblClients.fldLeadSource, tblClients.fldCompanyName, tblClients.fldGraduationYear, tblClients.fldState, tblClients.fldHome, tblClients.fldAdd1, tblClients.fldCity
FROM (tblClients LEFT JOIN tblSessions ON tblClients.fldCliID = tblSessions.fldCliID) INNER JOIN tblOrganizations ON tblClients.fldOrganizationID = tblOrganizations.fldOrganizationID
WHERE (((tblSessions.fldSesID) Is Null))
ORDER BY tblClients.fldCliNo±  ±True±Portrait±&lt;&lt;ParameterCount==2&gt;&gt;&lt;&lt;ParameterName1==Organization&gt;&gt;&lt;&lt;ParameterDescription1==Organization&gt;&gt;&lt;&lt;ParameterType1==0&gt;&gt;&lt;&lt;DefaultValue1==&gt;&gt;&lt;&lt;ParameterName2==GradYear&gt;&gt;&lt;&lt;ParameterDescription2==Grad Year (blank for all)&gt;&gt;&lt;&lt;ParameterType2==0&gt;&gt;&lt;&lt;DefaultValue2==&gt;&gt;±False±False±False±False±False±False±False±False±False±False±False±False±False±False±"
		ClassName="Normal"
		>
		</Control>
	</Section>
	<Section Type="GroupFooter" Name="GroupFooter1"
		Height="360"
	>
		<Control 
		Type="AR.Line"
		Name="Line2"
		X1="0"
		Y1="0"
		X2="10800"
		Y2="0"
		>
		</Control>
		<Control 
		Type="AR.Label"
		Name="Label8"
		Left="540"
		Top="90"
		Width="540"
		Height="270"
		Caption="Total:"
		ClassName="Normal"
		Style="font-weight: bold; font-size: 9pt; "
		>
		</Control>
		<Control 
		Type="AR.Field"
		Name="Field4"
		DataField="fldCliNo"
		Left="1080"
		Top="90"
		Width="1440"
		Height="270"
		Text="fldCliNo"
		SummaryType="3"
		SummaryFunc="2"
		SummaryRunning="1"
		SummaryGroup="GroupHeader1"
		SummaryDistinct="fldCliNo"
		ClassName="Normal"
		Style="font-size: 9pt; font-weight: bold; "
		>
		</Control>
	</Section>
	<Section Type="PageFooter" Name="PageFooter"
		Height="360"
	>
		<Control 
		Type="AR.Field"
		Name="Field1"
		DataField="=date"
		Left="90"
		Top="0"
		Width="3060"
		Height="360"
		Text="Date"
		ClassName="Normal"
		Style="font-size: 10pt; text-align: left; font-style: italic; "
		>
		</Control>
	</Section>
</Sections>
</ActiveReportsLayout>
